'use strict'

const pg=require('pg');

let psql=new pg.Pool({//连接池
    database:'shutterbug',
    User:'shutterbug',
    port:5432,
    host:'127.0.0.1', 
    password:'2022',
    //最大使用5个客户端连接
    max:5
})

//括号开头加分号
;(async()=>{

    let tm=Date.now();
    //随机字符串转成16进制并去掉前两位
    let id=`${Math.random().toString(16).substring(2)}`
    
    let sqltext=`INSERT INTO`
    +`  content(id,detail,title,add_time,update_time) `
    +` VALUES($1,$2,$3,$4,$5) `;

    let r=await psql.query(sqltext,[
        id,`测试内容:${Math.random()}`,'test',tm,tm
    ])

    console.log(r);
   
    //关闭连接
    psql.end();
    

})();